FO_INS_Policy_Messages
This table contains definitions of insurance and policy specific messages.
The insevalpolmsg permission must be assigned to enable this functionality. The message will display as the user exits the policy number field in the application if the insurance code and content of the policy number matches the definitions.
There can be more than one message per insurance.
If multiple values need to be compared with an “OR” statement for one insurance code, then more than one record should be created for the same insurance code. Each record will be evaluated separately and if the condition matches then that message will be displayed. When more than one message applies, the messages to display will be combined together into one message prompt.
Field | Type | Notes |
---|---|---|
Ins_PolMsg_ID |
bigint |
ID field, a counter. Unique |
InsCode |
varchar(50) |
Insurance code. Enter a valid insurance code. |
PolicyContainsText |
varchar(50) |
String(s) of text to be search for in the policy number. This is a ‘policy number contains’ search. Multidimensional pipe delimited value, with leading and trailing pipes. Enter the search strings, separated by pipes. For this message to display, every search string must be present. IE: |an|455| Policy AN123455 will show message Policy AN454123 will not show message |
UserMessage |
varchar(255) |
Enter the message to display if all pipe delimited strings from PolicyContainsText field above are present in the policy number. |
CreateDate |
datetime |
Date record was created. Informational |
CreateUser |
varchar(50) |
User who created record. Informational |
EditDate |
datetime |
Date record was last edited. Informational |
EditUser |
varchar(50) |
User who last edited record. Informational |